package com.bmps.springcloud.insuredmicroservice.repository.underwrite.coresystem;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;

/**
 * description:
 * 险种风险保额费率查询
 *
 * @author jackdaw
 * @date 2020-04-17 10:27
 */
@Repository
public interface InsuranceRiskAmountRepository {
    /**
     * 查询LLT008风险保额费率
     *
     * @param insuYear
     * @param age
     * @return
     */
    @Select("SELECT RATE FROM  LIS.RT_AMNT_LLT008 WHERE INSUYEAR=#{insuYear,jdbcType=INTEGER} AND AGE=#{age,jdbcType=INTEGER}")
    BigDecimal getRiskAmountRateLlt008(int insuYear, int age);
}
